package com.ruoyi.server.api.memberCoach.mapper;

import java.util.List;

import com.ruoyi.server.api.memberCoach.domain.MemberCoach;
import com.ruoyi.server.api.memberCoach.model.MemberCoachAndCoachManagement;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 会员用户教练关系Mapper接口
 *
 * @author zmh
 * @date 2024-06-12
 */
@Mapper
public interface MemberCoachMapper
{
    /**
     * 新增会员用户教练关系
     *
     * @param memberCoach 会员用户教练关系
     * @return 结果
     */
    public int insertMemberCoach(MemberCoach memberCoach);
    /**
    * @Author ZMH
    * @Description 根据用户id和租户标识查用该会员用户的信息
    * @Date 2024/6/13 11:29
    * @Return com.ruoyi.server.api.memberCoach.domain.MemberCoach
    * @param id venueUniqueIdentifier
    */
    List<MemberCoachAndCoachManagement> memberCoachById(@Param("id") Integer id, @Param("venueUniqueIdentifier") String venueUniqueIdentifier);
    /**
    * @Author ZMH
    * @Description 添加课程时长
    * @Date 2024/6/13 17:28
    * @Return
    * @param courseTime memberUserId courseId venueUniqueIdentifier
    */
    int addCourseTime(@Param("courseTime") Integer courseTime ,@Param("coachId") Integer coachId ,@Param("memberUserId") Integer memberUserId,@Param("venueUniqueIdentifier") String venueUniqueIdentifier);
    /**
     * @Author ZMH
     * @Description 退课程时长
     * @Date 2024/6/13 17:28
     * @Return
     * @param courseTime memberUserId courseId venueUniqueIdentifier
     */
//    int refundCourseTime(@Param("courseTime") Integer courseTime , @Param("courseId") Integer courseId , @Param("memberUserId") Integer memberUserId, @Param("venueUniqueIdentifier") String venueUniqueIdentifier);

    /**
    * @Author ZMH
    * @Description 根据教练id和会员id查询数据
    * @Date 2024/6/13 20:08
    * @Return
    * @param  memberUserId coachId venueUniqueIdentifier
    */
    MemberCoach selectMemberCoachById(@Param("coachId") Integer courseId, @Param("memberUserId") Integer memberUserId, @Param("venueUniqueIdentifier") String venueUniqueIdentifier);

}
